Skip to main content

QueryColumn

Index

ColumnColumn
QueryColumn.aggregationTypeQueryColumn.calenderGuid
QueryColumn.chartSpecificColumnTypeQueryColumn.columnProperties
QueryColumn.customOrderQueryColumn.dataType
QueryColumn.formatQueryColumn.id
QueryColumn.isMeasureValueQueryColumn.name
QueryColumn.timeBucketQueryColumn.type

Properties

aggregationType

aggregationType: ColumnAggregationType

Optional

Aggregation applied on the column data

calenderGuid

calenderGuid: string

Optional

Guid of Custom calender for the column if defined in worksheet else null

chartSpecificColumnType

chartSpecificColumnType: ChartSpecificColumnType

Type of arbitrary column, can be measure names or measure values also, unknown if regular column

columnProperties

columnProperties: {conditionalFormatting?: Maybe< ConditionalFormatting > , numberFormatting?: Maybe< FormatConfig > }

Optional

Column Properties of the columns

Parameters

conditionalFormatting

conditionalFormatting: Maybe

Optional

numberFormatting

numberFormatting: Maybe

Optional

customOrder

customOrder: string[]

Optional

Custom sort order defined for the column to sort charts in a specific order Defined in worksheet

dataType

dataType: DataType

Type of data for the column

format

format: ColumnFormat

Optional

Formatting for the columns defined in the worksheet

id

id: string

Column ID

isMeasureValue

isMeasureValue: boolean

Optional

Flag to identify if the column is a measure value, to be used along with MEASURE_NAME/MEASUE_VALUE column in the query

name

name: string

Column name property

timeBucket

timeBucket: ColumnTimeBucket

Type of the time-based aggregation when the column data is of type Date, Datetime, Time

type

type: ColumnType

Type of column if attribute or measure